package com.servlet;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.text.SimpleDateFormat;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class useredit extends HttpServlet {

	/**
	 * The doGet method of the servlet. <br>
	 *
	 * This method is called when a form has its tag value method equals to get.
	 * 
	 * @param request the request send by the client to the server
	 * @param response the response send by the server to the client
	 * @throws ServletException if an error occurred
	 * @throws IOException if an error occurred
	 */
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		   request. setCharacterEncoding("UTF-8");
		   String id = request.getParameter("id");
		   System.out.println("id="+id);
		   String username = request.getParameter("username");
		   String password = request.getParameter("password");
		   String utype = request.getParameter("role");
		   String name = request.getParameter("name");
		   String sex = request.getParameter("sex");
		   String age = request.getParameter("age");
		   String tel = request.getParameter("tel");
		   String email = request.getParameter("email");
		   String dept = request.getParameter("dept");
		   String status = request.getParameter("status");
		   try {
			Class.forName("com.mysql.jdbc.Driver");
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		   String url ="jdbc:mysql://localhost:3306/graduatedesign" ;
			  Connection conn = null ;
			  Statement stmt = null ;
			  ResultSet rs = null;
			  SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
			  
			  String sql="update user set username=?,password=?,utype=? where id="+id; 
			  try {
				conn = DriverManager.getConnection(url, "root", "root") ;
				stmt = conn.createStatement() ;
				PreparedStatement preStmt=conn.prepareStatement(sql);  
	            preStmt.setString(1, username);  
	            preStmt.setString(2, password); 
	            preStmt.setString(3, utype);
	            int suc = preStmt.executeUpdate(); 
	            if(suc!=0){
	            	String sql2="update userinfo set username=?,name=?,sex=?,age=?,tel=?,email=?,dept=?,status=? where username='" +username+"'";
	            	Connection conn1 = DriverManager.getConnection(url, "root", "root") ;
					PreparedStatement preStmt1=conn1.prepareStatement(sql2);  
		            preStmt1.setString(1, username);  
		            preStmt1.setString(2, name); 
		            preStmt1.setString(3, sex);
		            preStmt1.setString(4, age);
		            preStmt1.setString(5, tel);
		            preStmt1.setString(6, email);
		            preStmt1.setString(7, dept);
		            preStmt1.setString(8, status);
		            int suc1 = preStmt1.executeUpdate(); 
		            if (suc1!=0){
		            	response.sendRedirect("admin/user.jsp") ;
		            }
	            }
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
	}

	/**
	 * The doPost method of the servlet. <br>
	 *
	 * This method is called when a form has its tag value method equals to post.
	 * 
	 * @param request the request send by the client to the server
	 * @param response the response send by the server to the client
	 * @throws ServletException if an error occurred
	 * @throws IOException if an error occurred
	 */
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
        doGet(request, response);
	}
}
